﻿CREATE PROCEDURE [dbo].[UpdateCategory]
@CategoryID INT, @Name VARCHAR (100), @Abbreviation VARCHAR (10), @IsActive BIT
AS
UPDATE Categories
SET 	Name = @Name,
	Abbreviation = @Abbreviation,
	IsActive = @IsActive
WHERE CategoryID = @CategoryID


